CREATE TABLE [dbo].[JOL_Recruitment_ApplyingRecords]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[applicant_type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[applicant_userID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[recruit_position] [int] NULL,
[resume_path] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[add_time] [smalldatetime] NULL,
[user_add] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[update_time] [smalldatetime] NULL,
[user_update] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[last_stage] [int] NULL,
[handle_time] [smalldatetime] NULL,
[user_handle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[result] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[feedback_time] [smalldatetime] NULL,
[user_Feedback] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[employinunit_message] [text] COLLATE Chinese_PRC_CI_AS NULL,
[applicant_message] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_Recruitment_ApplyingRecords] ADD CONSTRAINT [PK_JOL_Recruitment_ApplyingRecords] PRIMARY KEY CLUSTERED  ([id]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'应聘者留言', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_ApplyingRecords', 'COLUMN', N'applicant_message'
GO
EXEC sp_addextendedproperty N'MS_Description', N'应聘者类型', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_ApplyingRecords', 'COLUMN', N'applicant_type'
GO
EXEC sp_addextendedproperty N'MS_Description', N'应聘者账号', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_ApplyingRecords', 'COLUMN', N'applicant_userID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'用人单位留言', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_ApplyingRecords', 'COLUMN', N'employinunit_message'
GO
EXEC sp_addextendedproperty N'MS_Description', N'反馈时间', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_ApplyingRecords', 'COLUMN', N'feedback_time'
GO
EXEC sp_addextendedproperty N'MS_Description', N'处理时间', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_ApplyingRecords', 'COLUMN', N'handle_time'
GO
EXEC sp_addextendedproperty N'MS_Description', N'最后处理阶段', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_ApplyingRecords', 'COLUMN', N'last_stage'
GO
EXEC sp_addextendedproperty N'MS_Description', N'招聘岗位', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_ApplyingRecords', 'COLUMN', N'recruit_position'
GO
EXEC sp_addextendedproperty N'MS_Description', N'处理结果', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_ApplyingRecords', 'COLUMN', N'result'
GO
EXEC sp_addextendedproperty N'MS_Description', N'简历路径', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_ApplyingRecords', 'COLUMN', N'resume_path'
GO
EXEC sp_addextendedproperty N'MS_Description', N'反馈账户', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_ApplyingRecords', 'COLUMN', N'user_Feedback'
GO
EXEC sp_addextendedproperty N'MS_Description', N'处理账户', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_ApplyingRecords', 'COLUMN', N'user_handle'
GO
